Dataset statistics
| Number of variables | 42 |
|---|---|
| Number of observations | 186523 |
| Missing cells | 6147 |
| Missing cells (%) | 0.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 59.8 MiB |
| Average record size in memory | 336.0 B |
Variable types
| NUM | 29 |
|---|---|
| BOOL | 7 |
| CAT | 6 |
flag_telefone has constant value "186523" | Constant |
nascimento has a high cardinality: 15116 distinct values | High cardinality |
data_contrato has a high cardinality: 84 distinct values | High cardinality |
tem_med_emp has a high cardinality: 189 distinct values | High cardinality |
tem_pri_emp has a high cardinality: 291 distinct values | High cardinality |
pri_emp_tom is highly correlated with pri_emp_san | High correlation |
pri_emp_san is highly correlated with pri_emp_tom | High correlation |
sec_emp_san is highly correlated with sec_emp_abt and 1 other fields | High correlation |
sec_emp_abt is highly correlated with sec_emp_san and 1 other fields | High correlation |
sec_emp_tom is highly correlated with sec_emp_abt and 1 other fields | High correlation |
emprego has 6147 (3.3%) missing values | Missing |
pri_emp_abt is highly skewed (γ1 = 30.69564031) | Skewed |
pri_emp_san is highly skewed (γ1 = 306.8631852) | Skewed |
pri_emp_tom is highly skewed (γ1 = 305.7799348) | Skewed |
sec_qtd_tot_emp is highly skewed (γ1 = 28.32622344) | Skewed |
sec_qtd_tot_emp_atv is highly skewed (γ1 = 31.15570999) | Skewed |
sec_qtd_tot_def is highly skewed (γ1 = 24.27761841) | Skewed |
sec_emp_abt is highly skewed (γ1 = 104.3726495) | Skewed |
sec_emp_san is highly skewed (γ1 = 73.22473392) | Skewed |
sec_emp_tom is highly skewed (γ1 = 73.71455172) | Skewed |
par_pri_emp is highly skewed (γ1 = 70.11203895) | Skewed |
par_seg_emp is highly skewed (γ1 = 153.6010717) | Skewed |
df_index has unique values | Unique |
id_pessoa has unique values | Unique |
score has 93698 (50.2%) zeros | Zeros |
pri_qtd_tot_emp has 93698 (50.2%) zeros | Zeros |
pri_qtd_tot_emp_atv has 109771 (58.9%) zeros | Zeros |
pri_qtd_tot_def has 165616 (88.8%) zeros | Zeros |
pri_emp_abt has 113463 (60.8%) zeros | Zeros |
pri_emp_san has 110630 (59.3%) zeros | Zeros |
pri_emp_tom has 110717 (59.4%) zeros | Zeros |
sec_qtd_tot_emp has 181821 (97.5%) zeros | Zeros |
sec_qtd_tot_emp_atv has 183450 (98.4%) zeros | Zeros |
sec_qtd_tot_def has 185430 (99.4%) zeros | Zeros |
sec_emp_abt has 183819 (98.6%) zeros | Zeros |
sec_emp_san has 183518 (98.4%) zeros | Zeros |
sec_emp_tom has 183542 (98.4%) zeros | Zeros |
par_pri_emp has 127636 (68.4%) zeros | Zeros |
par_seg_emp has 184739 (99.0%) zeros | Zeros |
nov_emp_6m has 145294 (77.9%) zeros | Zeros |
def_emp_6m has 172034 (92.2%) zeros | Zeros |
qtd_sol_emp has 161559 (86.6%) zeros | Zeros |
Reproduction
| Analysis started | 2020-10-02 18:39:36.128904 |
|---|---|
| Analysis finished | 2020-10-02 18:43:42.410166 |
| Duration | 4 minutes and 6.28 seconds |
| Software version | pandas-profiling v2.9.0 |
| Download configuration | config.yaml |
| Distinct | 186523 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 116450.0138 |
|---|---|
| Minimum | 0 |
| Maximum | 233153 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 11628.1 |
| Q1 | 58097.5 |
| median | 116400 |
| Q3 | 174698.5 |
| 95-th percentile | 221434.9 |
| Maximum | 233153 |
| Range | 233153 |
| Interquartile range (IQR) | 116601 |
Descriptive statistics
| Standard deviation | 67312.08146 |
|---|---|
| Coefficient of variation (CV) | 0.5780341219 |
| Kurtosis | -1.200723562 |
| Mean | 116450.0138 |
| Median Absolute Deviation (MAD) | 58301 |
| Skewness | 0.001925345223 |
| Sum | 2.172060592e+10 |
| Variance | 4530916311 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 2047 | 1 | < 0.1% | |
| 89473 | 1 | < 0.1% | |
| 175487 | 1 | < 0.1% | |
| 173438 | 1 | < 0.1% | |
| 179581 | 1 | < 0.1% | |
| 177532 | 1 | < 0.1% | |
| 167291 | 1 | < 0.1% | |
| 171385 | 1 | < 0.1% | |
| 169336 | 1 | < 0.1% | |
| 195957 | 1 | < 0.1% | |
| Other values (186513) | 186513 | > 99.9% |
| Value | Count | Frequency (%) | |
| 0 | 1 | < 0.1% | |
| 1 | 1 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 233153 | 1 | < 0.1% | |
| 233152 | 1 | < 0.1% | |
| 233151 | 1 | < 0.1% | |
| 233150 | 1 | < 0.1% | |
| 233149 | 1 | < 0.1% |
| Distinct | 186523 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 535857.1509 |
|---|---|
| Minimum | 417428 |
| Maximum | 671084 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 417428 |
|---|---|
| 5-th percentile | 429177.1 |
| Q1 | 476752.5 |
| median | 535850 |
| Q3 | 594974.5 |
| 95-th percentile | 642340.8 |
| Maximum | 671084 |
| Range | 253656 |
| Interquartile range (IQR) | 118222 |
Descriptive statistics
| Standard deviation | 68332.56085 |
|---|---|
| Coefficient of variation (CV) | 0.1275201063 |
| Kurtosis | -1.197307771 |
| Mean | 535857.1509 |
| Median Absolute Deviation (MAD) | 59112 |
| Skewness | -0.002015233297 |
| Sum | 9.994968336e+10 |
| Variance | 4669338872 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 526335 | 1 | < 0.1% | |
| 454007 | 1 | < 0.1% | |
| 445811 | 1 | < 0.1% | |
| 447856 | 1 | < 0.1% | |
| 421223 | 1 | < 0.1% | |
| 419174 | 1 | < 0.1% | |
| 423268 | 1 | < 0.1% | |
| 503135 | 1 | < 0.1% | |
| 501086 | 1 | < 0.1% | |
| 507229 | 1 | < 0.1% | |
| Other values (186513) | 186513 | > 99.9% |
| Value | Count | Frequency (%) | |
| 417428 | 1 | < 0.1% | |
| 417429 | 1 | < 0.1% | |
| 417430 | 1 | < 0.1% | |
| 417431 | 1 | < 0.1% | |
| 417432 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 671084 | 1 | < 0.1% | |
| 671033 | 1 | < 0.1% | |
| 658676 | 1 | < 0.1% | |
| 658675 | 1 | < 0.1% | |
| 658674 | 1 | < 0.1% |
valor_emprestimo
Real number (ℝ≥0)
| Distinct | 21749 |
|---|---|
| Distinct (%) | 11.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54353.68279 |
|---|---|
| Minimum | 13320 |
| Maximum | 990572 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 13320 |
|---|---|
| 5-th percentile | 34939 |
| Q1 | 47145 |
| median | 53803 |
| Q3 | 60401 |
| 95-th percentile | 74079 |
| Maximum | 990572 |
| Range | 977252 |
| Interquartile range (IQR) | 13256 |
Descriptive statistics
| Standard deviation | 13025.57436 |
|---|---|
| Coefficient of variation (CV) | 0.2396447433 |
| Kurtosis | 304.6867808 |
| Mean | 54353.68279 |
| Median Absolute Deviation (MAD) | 6644 |
| Skewness | 5.254190427 |
| Sum | 1.013821198e+10 |
| Variance | 169665587.4 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 48349 | 1726 | 0.9% | |
| 53303 | 1695 | 0.9% | |
| 51303 | 1578 | 0.8% | |
| 50303 | 1569 | 0.8% | |
| 55259 | 1507 | 0.8% | |
| 52303 | 1485 | 0.8% | |
| 47349 | 1462 | 0.8% | |
| 57259 | 1297 | 0.7% | |
| 56259 | 1284 | 0.7% | |
| 46349 | 1277 | 0.7% | |
| Other values (21739) | 171643 | 92.0% |
| Value | Count | Frequency (%) | |
| 13320 | 1 | < 0.1% | |
| 13369 | 1 | < 0.1% | |
| 13600 | 1 | < 0.1% | |
| 13640 | 1 | < 0.1% | |
| 13664 | 4 | < 0.1% |
| Value | Count | Frequency (%) | |
| 990572 | 1 | < 0.1% | |
| 987354 | 1 | < 0.1% | |
| 592460 | 1 | < 0.1% | |
| 332045 | 1 | < 0.1% | |
| 237779 | 1 | < 0.1% |
custo_ativo
Real number (ℝ≥0)
| Distinct | 42481 |
|---|---|
| Distinct (%) | 22.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 75854.33434 |
|---|---|
| Minimum | 37000 |
| Maximum | 1628992 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 37000 |
|---|---|
| 5-th percentile | 58251 |
| Q1 | 65717.5 |
| median | 70945 |
| Q3 | 79181 |
| 95-th percentile | 109635.7 |
| Maximum | 1628992 |
| Range | 1591992 |
| Interquartile range (IQR) | 13463.5 |
Descriptive statistics
| Standard deviation | 19060.17616 |
|---|---|
| Coefficient of variation (CV) | 0.2512733955 |
| Kurtosis | 352.8904128 |
| Mean | 75854.33434 |
| Median Absolute Deviation (MAD) | 6192 |
| Skewness | 6.93547847 |
| Sum | 1.414857800e+10 |
| Variance | 363290315.1 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 68000 | 548 | 0.3% | |
| 67000 | 479 | 0.3% | |
| 72000 | 423 | 0.2% | |
| 70000 | 397 | 0.2% | |
| 74000 | 377 | 0.2% | |
| 73000 | 372 | 0.2% | |
| 66000 | 370 | 0.2% | |
| 75000 | 364 | 0.2% | |
| 69000 | 351 | 0.2% | |
| 65000 | 320 | 0.2% | |
| Other values (42471) | 182522 | 97.9% |
| Value | Count | Frequency (%) | |
| 37000 | 2 | < 0.1% | |
| 37129 | 1 | < 0.1% | |
| 37230 | 1 | < 0.1% | |
| 37310 | 1 | < 0.1% | |
| 37816 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1628992 | 1 | < 0.1% | |
| 1328954 | 1 | < 0.1% | |
| 715186 | 1 | < 0.1% | |
| 459625 | 1 | < 0.1% | |
| 383600 | 1 | < 0.1% |
emprestimo_custo
Real number (ℝ≥0)
| Distinct | 6378 |
|---|---|
| Distinct (%) | 3.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 74.75372265 |
|---|---|
| Minimum | 14.17 |
| Maximum | 95 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 14.17 |
|---|---|
| 5-th percentile | 52.46 |
| Q1 | 68.87 |
| median | 76.8 |
| Q3 | 83.67 |
| 95-th percentile | 89.38 |
| Maximum | 95 |
| Range | 80.83 |
| Interquartile range (IQR) | 14.8 |
Descriptive statistics
| Standard deviation | 11.4304345 |
|---|---|
| Coefficient of variation (CV) | 0.1529078967 |
| Kurtosis | 1.275395213 |
| Mean | 74.75372265 |
| Median Absolute Deviation (MAD) | 7.27 |
| Skewness | -1.069009619 |
| Sum | 13943288.61 |
| Variance | 130.6548328 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 85 | 3493 | 1.9% | |
| 84.99 | 820 | 0.4% | |
| 79.99 | 448 | 0.2% | |
| 80 | 394 | 0.2% | |
| 79.9 | 332 | 0.2% | |
| 75 | 329 | 0.2% | |
| 74.93 | 312 | 0.2% | |
| 79.79 | 311 | 0.2% | |
| 89.89 | 274 | 0.1% | |
| 79.95 | 269 | 0.1% | |
| Other values (6368) | 179541 | 96.3% |
| Value | Count | Frequency (%) | |
| 14.17 | 1 | < 0.1% | |
| 15.3 | 1 | < 0.1% | |
| 15.58 | 1 | < 0.1% | |
| 17.05 | 1 | < 0.1% | |
| 17.13 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 95 | 6 | < 0.1% | |
| 94.99 | 4 | < 0.1% | |
| 94.98 | 8 | < 0.1% | |
| 94.97 | 5 | < 0.1% | |
| 94.96 | 11 | < 0.1% |
agencia
Real number (ℝ≥0)
| Distinct | 82 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 72.81785624 |
|---|---|
| Minimum | 1 |
| Maximum | 261 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 14 |
| median | 61 |
| Q3 | 130 |
| 95-th percentile | 249 |
| Maximum | 261 |
| Range | 260 |
| Interquartile range (IQR) | 116 |
Descriptive statistics
| Standard deviation | 69.80282204 |
|---|---|
| Coefficient of variation (CV) | 0.9585948507 |
| Kurtosis | 0.3058193865 |
| Mean | 72.81785624 |
| Median Absolute Deviation (MAD) | 50 |
| Skewness | 1.030977532 |
| Sum | 13582205 |
| Variance | 4872.433964 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 2 | 10481 | 5.6% | |
| 67 | 9116 | 4.9% | |
| 3 | 7419 | 4.0% | |
| 5 | 7396 | 4.0% | |
| 36 | 7058 | 3.8% | |
| 136 | 6259 | 3.4% | |
| 34 | 6224 | 3.3% | |
| 16 | 5168 | 2.8% | |
| 19 | 4678 | 2.5% | |
| 1 | 4592 | 2.5% | |
| Other values (72) | 118132 | 63.3% |
| Value | Count | Frequency (%) | |
| 1 | 4592 | 2.5% | |
| 2 | 10481 | 5.6% | |
| 3 | 7419 | 4.0% | |
| 5 | 7396 | 4.0% | |
| 7 | 2565 | 1.4% |
| Value | Count | Frequency (%) | |
| 261 | 141 | 0.1% | |
| 260 | 288 | 0.2% | |
| 259 | 285 | 0.2% | |
| 258 | 302 | 0.2% | |
| 257 | 980 | 0.5% |
revendedora
Real number (ℝ≥0)
| Distinct | 2924 |
|---|---|
| Distinct (%) | 1.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 19635.29279 |
|---|---|
| Minimum | 10524 |
| Maximum | 24803 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 10524 |
|---|---|
| 5-th percentile | 14180 |
| Q1 | 16535 |
| median | 20333 |
| Q3 | 23000 |
| 95-th percentile | 24119 |
| Maximum | 24803 |
| Range | 14279 |
| Interquartile range (IQR) | 6465 |
Descriptive statistics
| Standard deviation | 3491.178096 |
|---|---|
| Coefficient of variation (CV) | 0.1778011732 |
| Kurtosis | -1.47618857 |
| Mean | 19635.29279 |
| Median Absolute Deviation (MAD) | 3058 |
| Skewness | -0.1680836109 |
| Sum | 3662433718 |
| Variance | 12188324.5 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 18317 | 1128 | 0.6% | |
| 15694 | 1048 | 0.6% | |
| 15663 | 1026 | 0.6% | |
| 17980 | 1021 | 0.5% | |
| 14234 | 1001 | 0.5% | |
| 18166 | 960 | 0.5% | |
| 14375 | 914 | 0.5% | |
| 21980 | 911 | 0.5% | |
| 22727 | 873 | 0.5% | |
| 14145 | 847 | 0.5% | |
| Other values (2914) | 176794 | 94.8% |
| Value | Count | Frequency (%) | |
| 10524 | 6 | < 0.1% | |
| 12311 | 2 | < 0.1% | |
| 12312 | 39 | < 0.1% | |
| 12374 | 80 | < 0.1% | |
| 12441 | 39 | < 0.1% |
| Value | Count | Frequency (%) | |
| 24803 | 2 | < 0.1% | |
| 24802 | 2 | < 0.1% | |
| 24799 | 1 | < 0.1% | |
| 24797 | 1 | < 0.1% | |
| 24793 | 1 | < 0.1% |
montadora
Real number (ℝ≥0)
| Distinct | 11 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 69.0078489 |
|---|---|
| Minimum | 45 |
| Maximum | 156 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 45 |
|---|---|
| 5-th percentile | 45 |
| Q1 | 48 |
| median | 86 |
| Q3 | 86 |
| 95-th percentile | 86 |
| Maximum | 156 |
| Range | 111 |
| Interquartile range (IQR) | 38 |
Descriptive statistics
| Standard deviation | 22.11344458 |
|---|---|
| Coefficient of variation (CV) | 0.3204482524 |
| Kurtosis | -0.7243704664 |
| Mean | 69.0078489 |
| Median Absolute Deviation (MAD) | 34 |
| Skewness | 0.3859416686 |
| Sum | 12871551 |
| Variance | 489.0044312 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 86 | 87724 | 47.0% | |
| 45 | 45354 | 24.3% | |
| 51 | 21753 | 11.7% | |
| 48 | 13346 | 7.2% | |
| 49 | 8163 | 4.4% | |
| 120 | 7637 | 4.1% | |
| 67 | 1915 | 1.0% | |
| 145 | 616 | 0.3% | |
| 153 | 10 | < 0.1% | |
| 152 | 4 | < 0.1% |
| Value | Count | Frequency (%) | |
| 45 | 45354 | 24.3% | |
| 48 | 13346 | 7.2% | |
| 49 | 8163 | 4.4% | |
| 51 | 21753 | 11.7% | |
| 67 | 1915 | 1.0% |
| Value | Count | Frequency (%) | |
| 156 | 1 | < 0.1% | |
| 153 | 10 | < 0.1% | |
| 152 | 4 | < 0.1% | |
| 145 | 616 | 0.3% | |
| 120 | 7637 | 4.1% |
Current_pincode_ID
Real number (ℝ≥0)
| Distinct | 6510 |
|---|---|
| Distinct (%) | 3.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3400.717863 |
|---|---|
| Minimum | 1 |
| Maximum | 7345 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 263 |
| Q1 | 1511 |
| median | 2972 |
| Q3 | 5679 |
| 95-th percentile | 6943 |
| Maximum | 7345 |
| Range | 7344 |
| Interquartile range (IQR) | 4168 |
Descriptive statistics
| Standard deviation | 2238.301828 |
|---|---|
| Coefficient of variation (CV) | 0.6581851004 |
| Kurtosis | -1.288888058 |
| Mean | 3400.717863 |
| Median Absolute Deviation (MAD) | 1920 |
| Skewness | 0.2744225481 |
| Sum | 634312098 |
| Variance | 5009995.075 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 2578 | 1518 | 0.8% | |
| 1446 | 1378 | 0.7% | |
| 1515 | 885 | 0.5% | |
| 2989 | 746 | 0.4% | |
| 2943 | 730 | 0.4% | |
| 1509 | 693 | 0.4% | |
| 2782 | 671 | 0.4% | |
| 1794 | 641 | 0.3% | |
| 571 | 624 | 0.3% | |
| 3363 | 601 | 0.3% | |
| Other values (6500) | 178036 | 95.4% |
| Value | Count | Frequency (%) | |
| 1 | 19 | < 0.1% | |
| 2 | 53 | < 0.1% | |
| 3 | 37 | < 0.1% | |
| 4 | 70 | < 0.1% | |
| 5 | 178 | 0.1% |
| Value | Count | Frequency (%) | |
| 7345 | 6 | < 0.1% | |
| 7344 | 1 | < 0.1% | |
| 7343 | 1 | < 0.1% | |
| 7342 | 1 | < 0.1% | |
| 7341 | 4 | < 0.1% |
| Distinct | 15116 |
|---|---|
| Distinct (%) | 8.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| 01-01-90 | 1735 |
|---|---|
| 01-01-88 | 1719 |
| 01-01-87 | 1693 |
| 01-01-86 | 1657 |
| 01-01-85 | 1620 |
| Other values (15111) |
| Value | Count | Frequency (%) | |
| 01-01-90 | 1735 | 0.9% | |
| 01-01-88 | 1719 | 0.9% | |
| 01-01-87 | 1693 | 0.9% | |
| 01-01-86 | 1657 | 0.9% | |
| 01-01-85 | 1620 | 0.9% | |
| 01-01-89 | 1586 | 0.9% | |
| 01-01-91 | 1580 | 0.8% | |
| 01-01-95 | 1552 | 0.8% | |
| 01-01-92 | 1550 | 0.8% | |
| 01-01-93 | 1535 | 0.8% | |
| Other values (15106) | 170296 | 91.3% |
Unique
| Unique | 1666 ? |
|---|---|
| Unique (%) | 0.9% |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 6147 |
| Missing (%) | 3.3% |
| Memory size | 1.4 MiB |
| Self employed | |
|---|---|
| Salaried |
| Value | Count | Frequency (%) | |
| Self employed | 102028 | 54.7% | |
| Salaried | 78348 | 42.0% | |
| (Missing) | 6147 | 3.3% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 13 |
|---|---|
| Median length | 13 |
| Mean length | 10.57021922 |
| Min length | 3 |
| Distinct | 84 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| 31-10-18 | 7033 |
|---|---|
| 24-10-18 | 5366 |
| 31-08-18 | 5351 |
| 23-10-18 | 5182 |
| 26-10-18 | 4961 |
| Other values (79) |
| Value | Count | Frequency (%) | |
| 31-10-18 | 7033 | 3.8% | |
| 24-10-18 | 5366 | 2.9% | |
| 31-08-18 | 5351 | 2.9% | |
| 23-10-18 | 5182 | 2.8% | |
| 26-10-18 | 4961 | 2.7% | |
| 25-10-18 | 4715 | 2.5% | |
| 30-10-18 | 4705 | 2.5% | |
| 22-10-18 | 4692 | 2.5% | |
| 30-08-18 | 3779 | 2.0% | |
| 29-10-18 | 3497 | 1.9% | |
| Other values (74) | 137242 | 73.6% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
estado
Real number (ℝ≥0)
| Distinct | 22 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.259833908 |
|---|---|
| Minimum | 1 |
| Maximum | 22 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 4 |
| median | 6 |
| Q3 | 10 |
| 95-th percentile | 16 |
| Maximum | 22 |
| Range | 21 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 4.478373964 |
|---|---|
| Coefficient of variation (CV) | 0.6168700304 |
| Kurtosis | -0.3275150184 |
| Mean | 7.259833908 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.8217260468 |
| Sum | 1354126 |
| Variance | 20.05583336 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 4 | 35736 | 19.2% | |
| 3 | 27360 | 14.7% | |
| 6 | 26817 | 14.4% | |
| 13 | 14320 | 7.7% | |
| 9 | 12880 | 6.9% | |
| 8 | 11388 | 6.1% | |
| 5 | 8193 | 4.4% | |
| 14 | 7465 | 4.0% | |
| 1 | 7140 | 3.8% | |
| 7 | 5427 | 2.9% | |
| Other values (12) | 29797 | 16.0% |
| Value | Count | Frequency (%) | |
| 1 | 7140 | 3.8% | |
| 2 | 3319 | 1.8% | |
| 3 | 27360 | 14.7% | |
| 4 | 35736 | 19.2% | |
| 5 | 8193 | 4.4% |
| Value | Count | Frequency (%) | |
| 22 | 57 | < 0.1% | |
| 21 | 124 | 0.1% | |
| 20 | 146 | 0.1% | |
| 19 | 827 | 0.4% | |
| 18 | 4288 | 2.3% |
funcionario
Real number (ℝ≥0)
| Distinct | 3258 |
|---|---|
| Distinct (%) | 1.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1548.582807 |
|---|---|
| Minimum | 1 |
| Maximum | 3795 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 149 |
| Q1 | 712 |
| median | 1451 |
| Q3 | 2358 |
| 95-th percentile | 3185 |
| Maximum | 3795 |
| Range | 3794 |
| Interquartile range (IQR) | 1646 |
Descriptive statistics
| Standard deviation | 974.7103402 |
|---|---|
| Coefficient of variation (CV) | 0.6294208714 |
| Kurtosis | -1.050335125 |
| Mean | 1548.582807 |
| Median Absolute Deviation (MAD) | 810 |
| Skewness | 0.2455820427 |
| Sum | 288846311 |
| Variance | 950060.2473 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 2546 | 497 | 0.3% | |
| 620 | 399 | 0.2% | |
| 255 | 394 | 0.2% | |
| 2153 | 334 | 0.2% | |
| 130 | 332 | 0.2% | |
| 956 | 288 | 0.2% | |
| 751 | 287 | 0.2% | |
| 1494 | 286 | 0.2% | |
| 64 | 285 | 0.2% | |
| 908 | 281 | 0.2% | |
| Other values (3248) | 183140 | 98.2% |
| Value | Count | Frequency (%) | |
| 1 | 65 | < 0.1% | |
| 3 | 116 | 0.1% | |
| 4 | 60 | < 0.1% | |
| 5 | 75 | < 0.1% | |
| 7 | 114 | 0.1% |
| Value | Count | Frequency (%) | |
| 3795 | 1 | < 0.1% | |
| 3794 | 1 | < 0.1% | |
| 3791 | 3 | < 0.1% | |
| 3790 | 1 | < 0.1% | |
| 3789 | 2 | < 0.1% |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| 1 |
|---|
| Value | Count | Frequency (%) | |
| 1 | 186523 | 100.0% |
flag_aadhar
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| 1 | |
|---|---|
| 0 |
| Value | Count | Frequency (%) | |
| 1 | 156735 | 84.0% | |
| 0 | 29788 | 16.0% |
flag_pan
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| 0 | |
|---|---|
| 1 | 14063 |
| Value | Count | Frequency (%) | |
| 0 | 172460 | 92.5% | |
| 1 | 14063 | 7.5% |
flag_eleitor
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 159461 | 85.5% | |
| 1 | 27062 | 14.5% |
flag_cmotorista
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| 0 | |
|---|---|
| 1 | 4289 |
| Value | Count | Frequency (%) | |
| 0 | 182234 | 97.7% | |
| 1 | 4289 | 2.3% |
flag_passaporte
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| 0 | |
|---|---|
| 1 | 392 |
| Value | Count | Frequency (%) | |
| 0 | 186131 | 99.8% | |
| 1 | 392 | 0.2% |
| Distinct | 573 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 288.9711832 |
|---|---|
| Minimum | 0 |
| Maximum | 890 |
| Zeros | 93698 |
| Zeros (%) | 50.2% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 678 |
| 95-th percentile | 825 |
| Maximum | 890 |
| Range | 890 |
| Interquartile range (IQR) | 678 |
Descriptive statistics
| Standard deviation | 338.3142486 |
|---|---|
| Coefficient of variation (CV) | 1.170754277 |
| Kurtosis | -1.63277166 |
| Mean | 288.9711832 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 0.4482240891 |
| Sum | 53899772 |
| Variance | 114456.5308 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 93698 | 50.2% | |
| 300 | 7064 | 3.8% | |
| 738 | 6914 | 3.7% | |
| 825 | 5871 | 3.1% | |
| 15 | 3000 | 1.6% | |
| 17 | 2926 | 1.6% | |
| 763 | 2406 | 1.3% | |
| 16 | 2318 | 1.2% | |
| 708 | 1669 | 0.9% | |
| 737 | 1609 | 0.9% | |
| Other values (563) | 59048 | 31.7% |
| Value | Count | Frequency (%) | |
| 0 | 93698 | 50.2% | |
| 11 | 3 | < 0.1% | |
| 14 | 767 | 0.4% | |
| 15 | 3000 | 1.6% | |
| 16 | 2318 | 1.2% |
| Value | Count | Frequency (%) | |
| 890 | 3 | < 0.1% | |
| 884 | 1 | < 0.1% | |
| 879 | 51 | < 0.1% | |
| 878 | 5 | < 0.1% | |
| 873 | 7 | < 0.1% |
score_desc
Categorical
| Distinct | 20 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| No Bureau History Available | |
|---|---|
| C-Very Low Risk | |
| A-Very Low Risk | |
| D-Very Low Risk | 9093 |
| B-Very Low Risk | 7332 |
| Other values (15) |
| Value | Count | Frequency (%) | |
| No Bureau History Available | 93698 | 50.2% | |
| C-Very Low Risk | 12838 | 6.9% | |
| A-Very Low Risk | 11278 | 6.0% | |
| D-Very Low Risk | 9093 | 4.9% | |
| B-Very Low Risk | 7332 | 3.9% | |
| M-Very High Risk | 7064 | 3.8% | |
| F-Low Risk | 6847 | 3.7% | |
| K-High Risk | 6566 | 3.5% | |
| H-Medium Risk | 5449 | 2.9% | |
| E-Low Risk | 4628 | 2.5% | |
| Other values (10) | 21730 | 11.7% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 55 |
|---|---|
| Median length | 27 |
| Mean length | 22.21520134 |
| Min length | 10 |
| Distinct | 104 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.434048348 |
|---|---|
| Minimum | 0 |
| Maximum | 453 |
| Zeros | 93698 |
| Zeros (%) | 50.2% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 3 |
| 95-th percentile | 11 |
| Maximum | 453 |
| Range | 453 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 5.24306598 |
|---|---|
| Coefficient of variation (CV) | 2.154051699 |
| Kurtosis | 495.3134747 |
| Mean | 2.434048348 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 10.71977469 |
| Sum | 454006 |
| Variance | 27.48974087 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 93698 | 50.2% | |
| 1 | 27943 | 15.0% | |
| 2 | 15826 | 8.5% | |
| 3 | 10362 | 5.6% | |
| 4 | 7455 | 4.0% | |
| 5 | 5795 | 3.1% | |
| 6 | 4466 | 2.4% | |
| 7 | 3546 | 1.9% | |
| 8 | 2794 | 1.5% | |
| 9 | 2300 | 1.2% | |
| Other values (94) | 12338 | 6.6% |
| Value | Count | Frequency (%) | |
| 0 | 93698 | 50.2% | |
| 1 | 27943 | 15.0% | |
| 2 | 15826 | 8.5% | |
| 3 | 10362 | 5.6% | |
| 4 | 7455 | 4.0% |
| Value | Count | Frequency (%) | |
| 453 | 1 | < 0.1% | |
| 354 | 1 | < 0.1% | |
| 271 | 1 | < 0.1% | |
| 194 | 1 | < 0.1% | |
| 148 | 2 | < 0.1% |
| Distinct | 39 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.036268986 |
|---|---|
| Minimum | 0 |
| Maximum | 144 |
| Zeros | 109771 |
| Zeros (%) | 58.9% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 5 |
| Maximum | 144 |
| Range | 144 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.942854644 |
|---|---|
| Coefficient of variation (CV) | 1.874855536 |
| Kurtosis | 188.0254518 |
| Mean | 1.036268986 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.823731476 |
| Sum | 193288 |
| Variance | 3.774684168 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 109771 | 58.9% | |
| 1 | 33583 | 18.0% | |
| 2 | 17257 | 9.3% | |
| 3 | 9759 | 5.2% | |
| 4 | 5978 | 3.2% | |
| 5 | 3610 | 1.9% | |
| 6 | 2217 | 1.2% | |
| 7 | 1430 | 0.8% | |
| 8 | 954 | 0.5% | |
| 9 | 588 | 0.3% | |
| Other values (29) | 1376 | 0.7% |
| Value | Count | Frequency (%) | |
| 0 | 109771 | 58.9% | |
| 1 | 33583 | 18.0% | |
| 2 | 17257 | 9.3% | |
| 3 | 9759 | 5.2% | |
| 4 | 5978 | 3.2% |
| Value | Count | Frequency (%) | |
| 144 | 1 | < 0.1% | |
| 65 | 1 | < 0.1% | |
| 52 | 1 | < 0.1% | |
| 43 | 1 | < 0.1% | |
| 42 | 1 | < 0.1% |
| Distinct | 20 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.156045099 |
|---|---|
| Minimum | 0 |
| Maximum | 23 |
| Zeros | 165616 |
| Zeros (%) | 88.8% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 23 |
| Range | 23 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.5457297021 |
|---|---|
| Coefficient of variation (CV) | 3.497256278 |
| Kurtosis | 104.0289984 |
| Mean | 0.156045099 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 7.068909116 |
| Sum | 29106 |
| Variance | 0.2978209077 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 165616 | 88.8% | |
| 1 | 15851 | 8.5% | |
| 2 | 3437 | 1.8% | |
| 3 | 969 | 0.5% | |
| 4 | 322 | 0.2% | |
| 5 | 144 | 0.1% | |
| 6 | 76 | < 0.1% | |
| 7 | 32 | < 0.1% | |
| 8 | 22 | < 0.1% | |
| 9 | 19 | < 0.1% | |
| Other values (10) | 35 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 165616 | 88.8% | |
| 1 | 15851 | 8.5% | |
| 2 | 3437 | 1.8% | |
| 3 | 969 | 0.5% | |
| 4 | 322 | 0.2% |
| Value | Count | Frequency (%) | |
| 23 | 1 | < 0.1% | |
| 19 | 1 | < 0.1% | |
| 17 | 1 | < 0.1% | |
| 16 | 1 | < 0.1% | |
| 15 | 1 | < 0.1% |
| Distinct | 58811 |
|---|---|
| Distinct (%) | 31.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 166181.9059 |
|---|---|
| Minimum | -2018309 |
| Maximum | 96524920 |
| Zeros | 113463 |
| Zeros (%) | 60.8% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | -2018309 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 34860 |
| 95-th percentile | 801337.7 |
| Maximum | 96524920 |
| Range | 98543229 |
| Interquartile range (IQR) | 34860 |
Descriptive statistics
| Standard deviation | 967065.0273 |
|---|---|
| Coefficient of variation (CV) | 5.81931602 |
| Kurtosis | 1709.788142 |
| Mean | 166181.9059 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 30.69564031 |
| Sum | 3.099674764e+10 |
| Variance | 9.35214767e+11 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 113463 | 60.8% | |
| 800 | 100 | 0.1% | |
| 400 | 96 | 0.1% | |
| 100000 | 71 | < 0.1% | |
| 50000 | 68 | < 0.1% | |
| 40000 | 67 | < 0.1% | |
| 30000 | 67 | < 0.1% | |
| 25000 | 60 | < 0.1% | |
| 20000 | 55 | < 0.1% | |
| 60000 | 52 | < 0.1% | |
| Other values (58801) | 72424 | 38.8% |
| Value | Count | Frequency (%) | |
| -2018309 | 1 | < 0.1% | |
| -1738415 | 1 | < 0.1% | |
| -1408314 | 1 | < 0.1% | |
| -1306449 | 1 | < 0.1% | |
| -1178242 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 96524920 | 1 | < 0.1% | |
| 75603400 | 1 | < 0.1% | |
| 66406160 | 1 | < 0.1% | |
| 63531320 | 1 | < 0.1% | |
| 63359040 | 1 | < 0.1% |
| Distinct | 36559 |
|---|---|
| Distinct (%) | 19.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 219739.6944 |
|---|---|
| Minimum | 0 |
| Maximum | 1000000000 |
| Zeros | 110630 |
| Zeros (%) | 59.3% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 62000 |
| 95-th percentile | 1030000 |
| Maximum | 1000000000 |
| Range | 1000000000 |
| Interquartile range (IQR) | 62000 |
Descriptive statistics
| Standard deviation | 2602928.113 |
|---|---|
| Coefficient of variation (CV) | 11.84550711 |
| Kurtosis | 116769.9394 |
| Mean | 219739.6944 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 306.8631852 |
| Sum | 4.098650702e+10 |
| Variance | 6.77523476e+12 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 110630 | 59.3% | |
| 50000 | 1204 | 0.6% | |
| 30000 | 1133 | 0.6% | |
| 100000 | 782 | 0.4% | |
| 25000 | 752 | 0.4% | |
| 40000 | 702 | 0.4% | |
| 20000 | 685 | 0.4% | |
| 60000 | 476 | 0.3% | |
| 200000 | 472 | 0.3% | |
| 15000 | 445 | 0.2% | |
| Other values (36549) | 69242 | 37.1% |
| Value | Count | Frequency (%) | |
| 0 | 110630 | 59.3% | |
| 1 | 29 | < 0.1% | |
| 2 | 18 | < 0.1% | |
| 3 | 12 | < 0.1% | |
| 4 | 19 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1000000000 | 1 | < 0.1% | |
| 105865712 | 1 | < 0.1% | |
| 100425000 | 1 | < 0.1% | |
| 92622816 | 1 | < 0.1% | |
| 80327560 | 1 | < 0.1% |
| Distinct | 39362 |
|---|---|
| Distinct (%) | 21.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 219339.6203 |
|---|---|
| Minimum | 0 |
| Maximum | 1000000000 |
| Zeros | 110717 |
| Zeros (%) | 59.4% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 60067 |
| 95-th percentile | 1027987 |
| Maximum | 1000000000 |
| Range | 1000000000 |
| Interquartile range (IQR) | 60067 |
Descriptive statistics
| Standard deviation | 2606129.24 |
|---|---|
| Coefficient of variation (CV) | 11.88170763 |
| Kurtosis | 116198.2453 |
| Mean | 219339.6203 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 305.7799348 |
| Sum | 4.091188399e+10 |
| Variance | 6.791909615e+12 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 110717 | 59.4% | |
| 50000 | 1125 | 0.6% | |
| 30000 | 1054 | 0.6% | |
| 100000 | 765 | 0.4% | |
| 40000 | 638 | 0.3% | |
| 25000 | 598 | 0.3% | |
| 20000 | 530 | 0.3% | |
| 200000 | 479 | 0.3% | |
| 300000 | 441 | 0.2% | |
| 60000 | 424 | 0.2% | |
| Other values (39352) | 69752 | 37.4% |
| Value | Count | Frequency (%) | |
| 0 | 110717 | 59.4% | |
| 1 | 34 | < 0.1% | |
| 2 | 19 | < 0.1% | |
| 3 | 12 | < 0.1% | |
| 4 | 18 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1000000000 | 1 | < 0.1% | |
| 105755712 | 1 | < 0.1% | |
| 100425000 | 1 | < 0.1% | |
| 92628728 | 1 | < 0.1% | |
| 80349168 | 1 | < 0.1% |
| Distinct | 37 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.0609897975 |
|---|---|
| Minimum | 0 |
| Maximum | 52 |
| Zeros | 181821 |
| Zeros (%) | 97.5% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 52 |
| Range | 52 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.6570413928 |
|---|---|
| Coefficient of variation (CV) | 10.7729722 |
| Kurtosis | 1283.769316 |
| Mean | 0.0609897975 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 28.32622344 |
| Sum | 11376 |
| Variance | 0.4317033919 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 181821 | 97.5% | |
| 1 | 2745 | 1.5% | |
| 2 | 830 | 0.4% | |
| 3 | 362 | 0.2% | |
| 4 | 238 | 0.1% | |
| 5 | 119 | 0.1% | |
| 6 | 100 | 0.1% | |
| 8 | 60 | < 0.1% | |
| 7 | 58 | < 0.1% | |
| 9 | 33 | < 0.1% | |
| Other values (27) | 157 | 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 181821 | 97.5% | |
| 1 | 2745 | 1.5% | |
| 2 | 830 | 0.4% | |
| 3 | 362 | 0.2% | |
| 4 | 238 | 0.1% |
| Value | Count | Frequency (%) | |
| 52 | 1 | < 0.1% | |
| 46 | 2 | < 0.1% | |
| 42 | 1 | < 0.1% | |
| 38 | 2 | < 0.1% | |
| 37 | 1 | < 0.1% |
| Distinct | 22 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.02841472633 |
|---|---|
| Minimum | 0 |
| Maximum | 36 |
| Zeros | 183450 |
| Zeros (%) | 98.4% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 36 |
| Range | 36 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.3256757753 |
|---|---|
| Coefficient of variation (CV) | 11.4615137 |
| Kurtosis | 1835.099719 |
| Mean | 0.02841472633 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 31.15570999 |
| Sum | 5300 |
| Variance | 0.1060647106 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 183450 | 98.4% | |
| 1 | 2129 | 1.1% | |
| 2 | 526 | 0.3% | |
| 3 | 159 | 0.1% | |
| 4 | 104 | 0.1% | |
| 5 | 50 | < 0.1% | |
| 6 | 27 | < 0.1% | |
| 7 | 21 | < 0.1% | |
| 8 | 15 | < 0.1% | |
| 9 | 10 | < 0.1% | |
| Other values (12) | 32 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 183450 | 98.4% | |
| 1 | 2129 | 1.1% | |
| 2 | 526 | 0.3% | |
| 3 | 159 | 0.1% | |
| 4 | 104 | 0.1% |
| Value | Count | Frequency (%) | |
| 36 | 1 | < 0.1% | |
| 26 | 1 | < 0.1% | |
| 22 | 2 | < 0.1% | |
| 21 | 1 | < 0.1% | |
| 20 | 1 | < 0.1% |
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.007511138037 |
|---|---|
| Minimum | 0 |
| Maximum | 8 |
| Zeros | 185430 |
| Zeros (%) | 99.4% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 8 |
| Range | 8 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.1149469213 |
|---|---|
| Coefficient of variation (CV) | 15.30352934 |
| Kurtosis | 866.3538733 |
| Mean | 0.007511138037 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 24.27761841 |
| Sum | 1401 |
| Variance | 0.01321279471 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 185430 | 99.4% | |
| 1 | 916 | 0.5% | |
| 2 | 105 | 0.1% | |
| 3 | 38 | < 0.1% | |
| 4 | 19 | < 0.1% | |
| 5 | 8 | < 0.1% | |
| 6 | 5 | < 0.1% | |
| 8 | 1 | < 0.1% | |
| 7 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 185430 | 99.4% | |
| 1 | 916 | 0.5% | |
| 2 | 105 | 0.1% | |
| 3 | 38 | < 0.1% | |
| 4 | 19 | < 0.1% |
| Value | Count | Frequency (%) | |
| 8 | 1 | < 0.1% | |
| 7 | 1 | < 0.1% | |
| 6 | 5 | < 0.1% | |
| 5 | 8 | < 0.1% | |
| 4 | 19 | < 0.1% |
| Distinct | 2625 |
|---|---|
| Distinct (%) | 1.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5814.831436 |
|---|---|
| Minimum | -574647 |
| Maximum | 36032852 |
| Zeros | 183819 |
| Zeros (%) | 98.6% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | -574647 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 36032852 |
| Range | 36607499 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 184752.4064 |
|---|---|
| Coefficient of variation (CV) | 31.77261601 |
| Kurtosis | 15462.23426 |
| Mean | 5814.831436 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 104.3726495 |
| Sum | 1084599804 |
| Variance | 3.413345167e+10 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 183819 | 98.6% | |
| 800 | 8 | < 0.1% | |
| 400 | 7 | < 0.1% | |
| 100 | 6 | < 0.1% | |
| 589 | 5 | < 0.1% | |
| 1200 | 4 | < 0.1% | |
| 1070 | 4 | < 0.1% | |
| 20000 | 3 | < 0.1% | |
| 5000 | 3 | < 0.1% | |
| 12950 | 3 | < 0.1% | |
| Other values (2615) | 2661 | 1.4% |
| Value | Count | Frequency (%) | |
| -574647 | 1 | < 0.1% | |
| -155527 | 1 | < 0.1% | |
| -117138 | 1 | < 0.1% | |
| -31290 | 1 | < 0.1% | |
| -20000 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 36032852 | 1 | < 0.1% | |
| 29560540 | 1 | < 0.1% | |
| 24692024 | 1 | < 0.1% | |
| 22497172 | 1 | < 0.1% | |
| 19638280 | 1 | < 0.1% |
| Distinct | 1856 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7787.940903 |
|---|---|
| Minimum | 0 |
| Maximum | 30000000 |
| Zeros | 183518 |
| Zeros (%) | 98.4% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 30000000 |
| Range | 30000000 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 197362.8548 |
|---|---|
| Coefficient of variation (CV) | 25.34210997 |
| Kurtosis | 7966.347359 |
| Mean | 7787.940903 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 73.22473392 |
| Sum | 1452630101 |
| Variance | 3.895209645e+10 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 183518 | 98.4% | |
| 50000 | 65 | < 0.1% | |
| 100000 | 51 | < 0.1% | |
| 200000 | 33 | < 0.1% | |
| 40000 | 32 | < 0.1% | |
| 30000 | 31 | < 0.1% | |
| 10000 | 26 | < 0.1% | |
| 15000 | 26 | < 0.1% | |
| 25000 | 26 | < 0.1% | |
| 20000 | 25 | < 0.1% | |
| Other values (1846) | 2690 | 1.4% |
| Value | Count | Frequency (%) | |
| 0 | 183518 | 98.4% | |
| 1 | 3 | < 0.1% | |
| 8 | 2 | < 0.1% | |
| 9 | 1 | < 0.1% | |
| 18 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 30000000 | 1 | < 0.1% | |
| 26888200 | 1 | < 0.1% | |
| 25000000 | 1 | < 0.1% | |
| 19800000 | 1 | < 0.1% | |
| 18691002 | 1 | < 0.1% |
| Distinct | 2104 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7668.266058 |
|---|---|
| Minimum | 0 |
| Maximum | 30000000 |
| Zeros | 183542 |
| Zeros (%) | 98.4% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 30000000 |
| Range | 30000000 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 196767.7237 |
|---|---|
| Coefficient of variation (CV) | 25.66000216 |
| Kurtosis | 8056.586376 |
| Mean | 7668.266058 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 73.71455172 |
| Sum | 1430307990 |
| Variance | 3.871753707e+10 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 183542 | 98.4% | |
| 50000 | 46 | < 0.1% | |
| 100000 | 40 | < 0.1% | |
| 200000 | 31 | < 0.1% | |
| 40000 | 26 | < 0.1% | |
| 500000 | 22 | < 0.1% | |
| 300000 | 22 | < 0.1% | |
| 30000 | 19 | < 0.1% | |
| 150000 | 18 | < 0.1% | |
| 400000 | 17 | < 0.1% | |
| Other values (2094) | 2740 | 1.5% |
| Value | Count | Frequency (%) | |
| 0 | 183542 | 98.4% | |
| 1 | 3 | < 0.1% | |
| 8 | 2 | < 0.1% | |
| 9 | 1 | < 0.1% | |
| 18 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 30000000 | 1 | < 0.1% | |
| 26888200 | 1 | < 0.1% | |
| 25000000 | 1 | < 0.1% | |
| 19800000 | 1 | < 0.1% | |
| 18691002 | 1 | < 0.1% |
| Distinct | 24658 |
|---|---|
| Distinct (%) | 13.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13382.56195 |
|---|---|
| Minimum | 0 |
| Maximum | 25642806 |
| Zeros | 127636 |
| Zeros (%) | 68.4% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1998.5 |
| 95-th percentile | 26629.3 |
| Maximum | 25642806 |
| Range | 25642806 |
| Interquartile range (IQR) | 1998.5 |
Descriptive statistics
| Standard deviation | 161858.1317 |
|---|---|
| Coefficient of variation (CV) | 12.09470446 |
| Kurtosis | 7775.502538 |
| Mean | 13382.56195 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 70.11203895 |
| Sum | 2496155603 |
| Variance | 2.61980548e+10 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 127636 | 68.4% | |
| 1620 | 234 | 0.1% | |
| 1500 | 120 | 0.1% | |
| 1600 | 115 | 0.1% | |
| 2000 | 113 | 0.1% | |
| 2500 | 113 | 0.1% | |
| 1149 | 108 | 0.1% | |
| 1250 | 94 | 0.1% | |
| 1700 | 93 | < 0.1% | |
| 1565 | 80 | < 0.1% | |
| Other values (24648) | 57817 | 31.0% |
| Value | Count | Frequency (%) | |
| 0 | 127636 | 68.4% | |
| 1 | 3 | < 0.1% | |
| 2 | 3 | < 0.1% | |
| 3 | 17 | < 0.1% | |
| 4 | 11 | < 0.1% |
| Value | Count | Frequency (%) | |
| 25642806 | 1 | < 0.1% | |
| 20766553 | 1 | < 0.1% | |
| 17408822 | 1 | < 0.1% | |
| 15518546 | 1 | < 0.1% | |
| 15420411 | 1 | < 0.1% |
| Distinct | 1593 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 341.3471904 |
|---|---|
| Minimum | 0 |
| Maximum | 4170901 |
| Zeros | 184739 |
| Zeros (%) | 99.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 4170901 |
| Range | 4170901 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 16471.8578 |
|---|---|
| Coefficient of variation (CV) | 48.25543687 |
| Kurtosis | 32130.06834 |
| Mean | 341.3471904 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 153.6010717 |
| Sum | 63669102 |
| Variance | 271322099.4 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 184739 | 99.0% | |
| 5000 | 5 | < 0.1% | |
| 1065 | 5 | < 0.1% | |
| 833 | 5 | < 0.1% | |
| 1232 | 5 | < 0.1% | |
| 2100 | 5 | < 0.1% | |
| 1565 | 5 | < 0.1% | |
| 2400 | 4 | < 0.1% | |
| 1650 | 4 | < 0.1% | |
| 2065 | 4 | < 0.1% | |
| Other values (1583) | 1742 | 0.9% |
| Value | Count | Frequency (%) | |
| 0 | 184739 | 99.0% | |
| 1 | 2 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 5 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 4170901 | 1 | < 0.1% | |
| 3246710 | 1 | < 0.1% | |
| 1814000 | 1 | < 0.1% | |
| 1589946 | 1 | < 0.1% | |
| 1447600 | 1 | < 0.1% |
| Distinct | 25 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.3815079106 |
|---|---|
| Minimum | 0 |
| Maximum | 35 |
| Zeros | 145294 |
| Zeros (%) | 77.9% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 2 |
| Maximum | 35 |
| Range | 35 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.9578173187 |
|---|---|
| Coefficient of variation (CV) | 2.510609327 |
| Kurtosis | 50.46994352 |
| Mean | 0.3815079106 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.940283871 |
| Sum | 71160 |
| Variance | 0.917414016 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 145294 | 77.9% | |
| 1 | 25560 | 13.7% | |
| 2 | 8849 | 4.7% | |
| 3 | 3566 | 1.9% | |
| 4 | 1557 | 0.8% | |
| 5 | 757 | 0.4% | |
| 6 | 374 | 0.2% | |
| 7 | 246 | 0.1% | |
| 8 | 126 | 0.1% | |
| 9 | 66 | < 0.1% | |
| Other values (15) | 128 | 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 145294 | 77.9% | |
| 1 | 25560 | 13.7% | |
| 2 | 8849 | 4.7% | |
| 3 | 3566 | 1.9% | |
| 4 | 1557 | 0.8% |
| Value | Count | Frequency (%) | |
| 35 | 1 | < 0.1% | |
| 28 | 1 | < 0.1% | |
| 23 | 2 | < 0.1% | |
| 21 | 1 | < 0.1% | |
| 20 | 3 | < 0.1% |
| Distinct | 14 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.09701752599 |
|---|---|
| Minimum | 0 |
| Maximum | 20 |
| Zeros | 172034 |
| Zeros (%) | 92.2% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 20 |
| Range | 20 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.3836828182 |
|---|---|
| Coefficient of variation (CV) | 3.95477842 |
| Kurtosis | 103.5947152 |
| Mean | 0.09701752599 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 6.708168452 |
| Sum | 18096 |
| Variance | 0.147212505 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 172034 | 92.2% | |
| 1 | 11905 | 6.4% | |
| 2 | 1956 | 1.0% | |
| 3 | 432 | 0.2% | |
| 4 | 106 | 0.1% | |
| 5 | 49 | < 0.1% | |
| 6 | 16 | < 0.1% | |
| 7 | 12 | < 0.1% | |
| 8 | 5 | < 0.1% | |
| 12 | 2 | < 0.1% | |
| Other values (4) | 6 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 172034 | 92.2% | |
| 1 | 11905 | 6.4% | |
| 2 | 1956 | 1.0% | |
| 3 | 432 | 0.2% | |
| 4 | 106 | 0.1% |
| Value | Count | Frequency (%) | |
| 20 | 1 | < 0.1% | |
| 12 | 2 | < 0.1% | |
| 11 | 2 | < 0.1% | |
| 10 | 1 | < 0.1% | |
| 9 | 2 | < 0.1% |
| Distinct | 189 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| 0yrs 0mon | |
|---|---|
| 0yrs 6mon | 4766 |
| 0yrs 7mon | 4299 |
| 0yrs 11mon | 4214 |
| 0yrs 10mon | 4091 |
| Other values (184) |
| Value | Count | Frequency (%) | |
| 0yrs 0mon | 95599 | 51.3% | |
| 0yrs 6mon | 4766 | 2.6% | |
| 0yrs 7mon | 4299 | 2.3% | |
| 0yrs 11mon | 4214 | 2.3% | |
| 0yrs 10mon | 4091 | 2.2% | |
| 0yrs 9mon | 4040 | 2.2% | |
| 1yrs 0mon | 3975 | 2.1% | |
| 0yrs 8mon | 3877 | 2.1% | |
| 1yrs 1mon | 3588 | 1.9% | |
| 0yrs 5mon | 3529 | 1.9% | |
| Other values (179) | 54545 | 29.2% |
Unique
| Unique | 25 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 11 |
|---|---|
| Median length | 9 |
| Mean length | 9.077019992 |
| Min length | 9 |
| Distinct | 291 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| 0yrs 0mon | |
|---|---|
| 0yrs 6mon | 3795 |
| 2yrs 1mon | 3776 |
| 0yrs 7mon | 3234 |
| 2yrs 0mon | 3051 |
| Other values (286) |
| Value | Count | Frequency (%) | |
| 0yrs 0mon | 95405 | 51.1% | |
| 0yrs 6mon | 3795 | 2.0% | |
| 2yrs 1mon | 3776 | 2.0% | |
| 0yrs 7mon | 3234 | 1.7% | |
| 2yrs 0mon | 3051 | 1.6% | |
| 1yrs 0mon | 2672 | 1.4% | |
| 1yrs 1mon | 2444 | 1.3% | |
| 0yrs 11mon | 2052 | 1.1% | |
| 0yrs 8mon | 1937 | 1.0% | |
| 0yrs 9mon | 1900 | 1.0% | |
| Other values (281) | 66257 | 35.5% |
Unique
| Unique | 45 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 11 |
|---|---|
| Median length | 9 |
| Mean length | 9.090428526 |
| Min length | 9 |
| Distinct | 23 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.2061515202 |
|---|---|
| Minimum | 0 |
| Maximum | 36 |
| Zeros | 161559 |
| Zeros (%) | 86.6% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 36 |
| Range | 36 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.7017413349 |
|---|---|
| Coefficient of variation (CV) | 3.404007568 |
| Kurtosis | 127.6281962 |
| Mean | 0.2061515202 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 7.710467395 |
| Sum | 38452 |
| Variance | 0.4924409011 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 161559 | 86.6% | |
| 1 | 17843 | 9.6% | |
| 2 | 4357 | 2.3% | |
| 3 | 1389 | 0.7% | |
| 4 | 608 | 0.3% | |
| 5 | 265 | 0.1% | |
| 6 | 193 | 0.1% | |
| 7 | 103 | 0.1% | |
| 8 | 87 | < 0.1% | |
| 9 | 33 | < 0.1% | |
| Other values (13) | 86 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 161559 | 86.6% | |
| 1 | 17843 | 9.6% | |
| 2 | 4357 | 2.3% | |
| 3 | 1389 | 0.7% | |
| 4 | 608 | 0.3% |
| Value | Count | Frequency (%) | |
| 36 | 1 | < 0.1% | |
| 23 | 1 | < 0.1% | |
| 22 | 1 | < 0.1% | |
| 19 | 5 | < 0.1% | |
| 18 | 3 | < 0.1% |
default
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 146161 | 78.4% | |
| 1 | 40362 | 21.6% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| df_index | id_pessoa | valor_emprestimo | custo_ativo | emprestimo_custo | agencia | revendedora | montadora | Current_pincode_ID | nascimento | emprego | data_contrato | estado | funcionario | flag_telefone | flag_aadhar | flag_pan | flag_eleitor | flag_cmotorista | flag_passaporte | score | score_desc | pri_qtd_tot_emp | pri_qtd_tot_emp_atv | pri_qtd_tot_def | pri_emp_abt | pri_emp_san | pri_emp_tom | sec_qtd_tot_emp | sec_qtd_tot_emp_atv | sec_qtd_tot_def | sec_emp_abt | sec_emp_san | sec_emp_tom | par_pri_emp | par_seg_emp | nov_emp_6m | def_emp_6m | tem_med_emp | tem_pri_emp | qtd_sol_emp | default | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 155653 | 487469 | 63418 | 75571 | 85.00 | 136 | 14189 | 86 | 3783 | 10-05-76 | Salaried | 03-09-18 | 8 | 2064 | 1 | 1 | 0 | 0 | 0 | 0 | 676 | F-Low Risk | 41 | 16 | 2 | 1365190 | 1454300 | 1454300 | 0 | 0 | 0 | 0 | 0 | 0 | 3746800 | 0 | 3 | 0 | 0yrs 8mon | 5yrs 5mon | 0 | 0 |
| 1 | 98628 | 627194 | 42494 | 69042 | 65.18 | 1 | 22056 | 45 | 4923 | 05-02-97 | Self employed | 26-10-18 | 3 | 1298 | 1 | 0 | 0 | 1 | 0 | 0 | 824 | A-Very Low Risk | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1yrs 1mon | 1yrs 1mon | 0 | 0 |
| 2 | 132937 | 636647 | 56909 | 69407 | 84.86 | 5 | 17980 | 86 | 3396 | 06-05-83 | Salaried | 29-10-18 | 9 | 679 | 1 | 0 | 0 | 1 | 0 | 0 | 755 | C-Very Low Risk | 14 | 4 | 0 | 12162 | 97826 | 26664 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0yrs 5mon | 1yrs 4mon | 0 | 0 |
| 3 | 29031 | 518430 | 69488 | 82782 | 85.00 | 19 | 14375 | 86 | 1838 | 07-01-83 | Self employed | 19-09-18 | 4 | 603 | 1 | 1 | 0 | 0 | 0 | 0 | 604 | H-Medium Risk | 5 | 2 | 0 | 68664 | 80000 | 80000 | 0 | 0 | 0 | 0 | 0 | 0 | 11840 | 0 | 2 | 0 | 1yrs 1mon | 3yrs 1mon | 7 | 0 |
| 4 | 67486 | 577759 | 54963 | 66783 | 84.90 | 74 | 22928 | 86 | 2578 | 01-01-94 | Salaried | 14-10-18 | 4 | 286 | 1 | 1 | 0 | 0 | 0 | 0 | 737 | C-Very Low Risk | 3 | 1 | 0 | 36654 | 57131 | 57131 | 0 | 0 | 0 | 0 | 0 | 0 | 2658 | 0 | 0 | 0 | 0yrs 10mon | 1yrs 4mon | 0 | 0 |
| 5 | 45170 | 576606 | 52678 | 64970 | 82.50 | 147 | 17694 | 45 | 2782 | 16-06-92 | Salaried | 13-10-18 | 2 | 242 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | No Bureau History Available | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0yrs 0mon | 0yrs 0mon | 0 | 1 |
| 6 | 158563 | 543198 | 49078 | 77221 | 66.04 | 255 | 23415 | 45 | 5829 | 01-01-80 | Self employed | 27-09-18 | 3 | 2079 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | No Bureau History Available | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0yrs 0mon | 0yrs 0mon | 0 | 1 |
| 7 | 85119 | 459958 | 58342 | 72199 | 83.80 | 135 | 22831 | 120 | 1694 | 26-03-79 | Self employed | 23-08-18 | 4 | 175 | 1 | 1 | 0 | 0 | 0 | 0 | 300 | M-Very High Risk | 3 | 2 | 2 | 339169 | 1144500 | 1144500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1yrs 4mon | 1yrs 11mon | 0 | 0 |
| 8 | 90337 | 598106 | 62947 | 76638 | 84.81 | 103 | 20535 | 45 | 7004 | 17-09-95 | Self employed | 22-10-18 | 7 | 1281 | 1 | 0 | 0 | 1 | 0 | 0 | 612 | H-Medium Risk | 1 | 1 | 0 | 4269 | 42168 | 42168 | 0 | 0 | 0 | 0 | 0 | 0 | 2206 | 0 | 0 | 1 | 1yrs 11mon | 1yrs 11mon | 0 | 0 |
| 9 | 76243 | 622880 | 68517 | 88500 | 79.32 | 248 | 23337 | 51 | 1774 | 26-07-96 | Salaried | 26-10-18 | 4 | 422 | 1 | 1 | 0 | 0 | 0 | 0 | 738 | C-Very Low Risk | 3 | 1 | 0 | 79169 | 92000 | 92000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0yrs 11mon | 1yrs 3mon | 0 | 0 |
Last rows
| df_index | id_pessoa | valor_emprestimo | custo_ativo | emprestimo_custo | agencia | revendedora | montadora | Current_pincode_ID | nascimento | emprego | data_contrato | estado | funcionario | flag_telefone | flag_aadhar | flag_pan | flag_eleitor | flag_cmotorista | flag_passaporte | score | score_desc | pri_qtd_tot_emp | pri_qtd_tot_emp_atv | pri_qtd_tot_def | pri_emp_abt | pri_emp_san | pri_emp_tom | sec_qtd_tot_emp | sec_qtd_tot_emp_atv | sec_qtd_tot_def | sec_emp_abt | sec_emp_san | sec_emp_tom | par_pri_emp | par_seg_emp | nov_emp_6m | def_emp_6m | tem_med_emp | tem_pri_emp | qtd_sol_emp | default | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 186513 | 170573 | 510770 | 56759 | 67143 | 86.38 | 15 | 15733 | 86 | 300 | 01-01-78 | Self employed | 16-09-18 | 11 | 2275 | 1 | 1 | 0 | 0 | 0 | 0 | 16 | Not Scored: No Activity seen on the customer (Inactive) | 1 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 0 | 3956796 | 4050000 | 4048617 | 0 | 1100 | 0 | 0 | 1yrs 1mon | 2yrs 2mon | 0 | 0 |
| 186514 | 96696 | 626144 | 58947 | 81600 | 74.75 | 104 | 21531 | 49 | 7148 | 11-01-94 | Self employed | 26-10-18 | 10 | 900 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | No Bureau History Available | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0yrs 0mon | 0yrs 0mon | 1 | 0 |
| 186515 | 36985 | 429239 | 51578 | 68000 | 77.94 | 248 | 14791 | 45 | 1789 | 21-07-94 | Salaried | 09-08-18 | 4 | 166 | 1 | 1 | 0 | 0 | 0 | 0 | 17 | Not Scored: Not Enough Info available on the customer | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8yrs 5mon | 8yrs 5mon | 0 | 0 |
| 186516 | 176963 | 525238 | 57659 | 71260 | 83.22 | 18 | 14115 | 86 | 2694 | 01-01-80 | Self employed | 21-09-18 | 4 | 2605 | 1 | 1 | 0 | 0 | 0 | 0 | 309 | L-Very High Risk | 6 | 3 | 2 | 346688 | 357500 | 357500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1yrs 2mon | 1yrs 7mon | 0 | 0 |
| 186517 | 139443 | 451783 | 51803 | 66002 | 80.30 | 5 | 14145 | 86 | 3345 | 10-09-80 | Salaried | 21-08-18 | 9 | 841 | 1 | 0 | 0 | 1 | 0 | 0 | 483 | K-High Risk | 36 | 13 | 8 | 330430 | 601990 | 601990 | 0 | 0 | 0 | 0 | 0 | 0 | 8981 | 0 | 2 | 0 | 2yrs 0mon | 10yrs 1mon | 0 | 0 |
| 186518 | 158885 | 578514 | 51078 | 71008 | 73.23 | 29 | 24377 | 49 | 5930 | 01-12-97 | NaN | 15-10-18 | 3 | 2082 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | No Bureau History Available | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0yrs 0mon | 0yrs 0mon | 0 | 0 |
| 186519 | 144610 | 557346 | 38694 | 66042 | 61.02 | 2 | 22561 | 45 | 2381 | 12-07-93 | Salaried | 04-10-18 | 4 | 536 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | No Bureau History Available | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0yrs 0mon | 0yrs 0mon | 0 | 0 |
| 186520 | 204677 | 647122 | 51913 | 66810 | 78.75 | 84 | 17433 | 86 | 2933 | 01-01-61 | Self employed | 31-10-18 | 21 | 2767 | 1 | 1 | 0 | 0 | 0 | 0 | 300 | M-Very High Risk | 9 | 5 | 2 | 1418217 | 1462307 | 1462307 | 0 | 0 | 0 | 0 | 0 | 0 | 7428 | 0 | 0 | 0 | 2yrs 7mon | 5yrs 3mon | 1 | 1 |
| 186521 | 68304 | 459266 | 60007 | 71460 | 85.45 | 76 | 16596 | 86 | 4426 | 26-05-79 | Self employed | 23-08-18 | 8 | 693 | 1 | 1 | 0 | 0 | 0 | 0 | 783 | B-Very Low Risk | 5 | 3 | 0 | 1577565 | 2057000 | 2057000 | 0 | 0 | 0 | 0 | 0 | 0 | 1260 | 0 | 1 | 0 | 1yrs 7mon | 2yrs 10mon | 0 | 0 |
| 186522 | 57003 | 467189 | 53078 | 62526 | 87.96 | 20 | 14004 | 86 | 6239 | 01-01-82 | Self employed | 27-08-18 | 5 | 1903 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | No Bureau History Available | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0yrs 0mon | 0yrs 0mon | 0 | 1 |